package com.dxg.msns.user.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dxg.msns.user.pojo.SingerGrade;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface SingerGradeMapper extends BaseMapper<SingerGrade> {
    @Select("SELECT * FROM singer_grade WHERE singer_id = #{singerId} AND user_id = #{userId} AND status = 0 LIMIT 1")
    SingerGrade findBySingerIdAndUserId(@Param("singerId") String singerId, @Param("userId") String userId);
}
